Copy to Historical Gift Table

Copy Gift Values to Historical Gift Table

Copy Gift Values to Historical Gift Table allows you to copy Market Values, FASB Amounts, and Reserve Values from gift records into the Historical Gift table. While FASB Liabilities, CashTrac CGA Market Values and computing PIF market values include the option to store in the Historical Gift Table the new values they've computed, Copy Gift Values to Historical Gift Table allows you to copy these values to the Historical Gift Table at any later time. Storing these values in this way will allow you to review or retrieve them later, even after you have updated these same values in each gift record.

1. Click Actions > Copy Gift to Historical Gift Table in the Menu Bar.

2. Enter selection criteria for the gift values you wish to store as historical gift values. There is help available on each field.

3. Click OK.

If you get an error log window, see Notes below.

4. Review the number and sum of the values you are about to store as historical gift values. If they look correct, click Yes to proceed with storing the values. Click No to terminate the function without storing values.

5. If you are warned that you are about to overwrite a previously stored value for the same gift, click Continue to overwrite this stored value with the new value. Click Cancel to terminate the function without storing values.

6. Click Close.

Notes:

· Being able to retrieve Market Values and FASB Liabilities can be very useful. If you ever make a mistake when storing a new set of these values using the FASB Liabilities, CashTrac CGA Market Values, or Compute PIF Market Values functions, you can restore these values from the Historical Gift table if you have stored them there.

If you store Market Values or FASB Amounts in the Historical Gift table, you can produce a report that lists the values from two dates and the difference between them. This capability is especially useful for FASB Liability reports, as it lets you report the change in liability over your charity's fiscal year, an amount that must appear on your charity's annual financial statement.
If you store FASB Values in the Historical Gift table, you can produce a file of the values from two dates and the difference between them that is suitable for uploading to your general ledger software. This file can be saved in comma and quotes text format (.csv) or fixed-length text format (.sdf).